Dear All

I wont to retrieve data from [OperationsManagerDW] SCOM DB.

i wont to find all monitored devices(servers,application Servers and web services).

i must prepare a report to calculate devices availability(i have some IP servers).

How  can i find where server names are stored,their IP and availability or downtime,something else.

Thank-you! 

Below links should help you -

http://blogs.technet.com/b/kevinholman/archive/2007/10/18/useful-operations-manager-2007-sql-queries.aspx

https://social.technet.microsoft.com/Forums/systemcenter/en-US/c3c795bf-94f2-48ec-a8ab-f00ec949a6b9/scom-sql-query-to-find-agent-status-and-status-details

http://opsit.blogspot.com/2013/11/useful-sql-queries-in-scom-database.html